Create new Model
Create a new table model
Step
1
- Copy pest the Main table 3
times
- Rename
the first table Zika-Confirmed
- Rename
the Second t table Zika-Deaths
- Rename the third table Zika-Suspected
Step
2
-
Select
FDF, Country/territory, Data Publication date and case columns (By Using hold ctrl
and click the columns)
-
Click
Remove Column and Select Remove Other Columns
-
Rename
The case Column by Confirmed
-
Remove
FDF column
Step
3
- Filter the FDF by Deaths Only
-
Select
FDF, Country/territory, Data Publication date and case columns (By Using hold ctrl
and click the columns)
-
Click
Remove Column and Select Remove Other Columns
-
Rename
The case Column by Deaths
-
Remove
FDF column
Step
4
Create Zika-Suspected table
-
Filter
the FDF by Suspected Only
-
Select
FDF, Country/territory, Data Publication date and case columns (By Using hold ctrl
and click the columns)
-
Click
Remove Column and Select Remove Other Columns
-
Rename
The case Column by Suspected
-
Remove
FDF column
Create a Date table
Steps
-
Click on Modeling
-
Select New Table
- Put below DAX code
Date = ADDCOLUMNS (
CALENDAR (Min('Zika-cases'[Data Publication
Date]), MAX('Zika-cases'[Data Publication Date])),
"Dates", FORMAT ( [Date],
"MM/DD/YYYY" ),
"DateAsInteger", FORMAT ( [Date],
"YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date],
"MM" ),
"YearMonthnumber", FORMAT ( [Date],
"YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date],
"YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date],
"mmm" ),
"Month", FORMAT ( [Date],
"mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date]
),
"DayOfWeek", FORMAT ( [Date],
"dddd" ),
"DayOfWeekShort", FORMAT ( [Date],
"ddd" ),
"Quarter", "Q" &
FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date],
"YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)
Make Relationship
below like help to see how we build a data model
https://www.youtube.com/watch?v=dmSDvWyLl2E